Preserving Data Integrity in HDDBSs Using Quasi Serializable Executions
نویسندگان
چکیده
منابع مشابه
Maintaining HDDBS consistence: The Quasi Serializability approach
In this paper, we introduce quasi serializability, a correctness criterion for concurrency control in heterogeneous distributed database systems (HDDBSs). Quasi serializability is a weaker criterion than serializability in that it only controls execution of global transactions. Quasi serializability is suited to HDDBS applications where local concurrency controllers (LeGs) maintain serializabil...
متن کاملSerializable Executions with Snapshot Isolation: Modifying Application Code or Mixing Isolation Levels?
Snapshot Isolation concurrency control (SI) allows substantial performance gains compared to holding commit-duration readlocks, while still avoiding many anomalies such as lost updates or inconsistent reads. However, for some sets of application programs, SI can result in non-serializable execution, in which database integrity constraints can be violated. The literature reports two different ap...
متن کاملOn Relaxing Serializability by Constraining
| Although, concurrency control in database systems is primarily based on serializability, many recent applications have rendered traditional serializability-based criteria ineecient or inappropriate. However, non-serializable executions may violate database consistency. In this paper, we propose a new approach to ensuring the correctness of non-serializable executions. The approach is based on...
متن کاملOn Relaxing Serializability by Constraining Transaction Readsets
Although, concurrency control in database systems is primarily based on serializability, many recent applications have rendered traditional serializability-based criteria inefficient or inappropriate. However, non-serializable executions may violate database consistency. In this paper, we propose a new approach to ensuring the correctness of non-serializable executions. The approach is based on...
متن کاملPerformance of program modification techniques that ensure serializable executions with snapshot isolation DBMS
Snapshot Isolation (SI) is a multiversion concurrency control that has been implemented by several open source and commercial database systems (Oracle, PostgreSQL, Microsoft SQL Server). The main feature of SI is that a read operation does not block a write operation and vice versa, which allows higher degree of concurrency than traditional two-phase locking. SI prevents many anomalies that app...
متن کاملذخیره در منابع من
با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید
عنوان ژورنال:
دوره شماره
صفحات -
تاریخ انتشار 2013